package com.whmskj.xjlhbc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.whmskj.xjlhbc.domain.MachineInfo;
import com.whmskj.xjlhbc.vo.RealInfoVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MachineInfoMapper extends BaseMapper<MachineInfo> {


    @Select("select sum(stopcount_total) total,sum(stoptime_total) stoptime,dateymd type from stopdata_info_class where macid=#{macid} and dateymd between #{start} and #{end} group by dateymd")
    List<RealInfoVo.StopInfo> bytc(@Param("macid") String macid, @Param("start") String start, @Param("end") String end);
}
